revDatabaseColumnNames

Type

function

Summary

Returns the list of database field names in a record set (database cursor)(glossary) or a database table

Syntax

revDatabaseColumnNames(<recordSetOrConnectionId> [, <tableName>])

Description

Use the revDatabaseColumnNames function to find out what database fields are in the record set returned by a SQL query or what database fields are contained within a certain table.

There are two forms of the revDatabaseColumnNames function. It can either be used to return the list of column names in a record set, or as of LiveCode 2.9, the list of columns in a given table.

To get the list of columns in a record set use a form like this:

    get revDatabaseColumnNames(tRecordSetId)

To get the list of columns in a given table, use a form like this:

    get revDatabaseColumnNames(tConnectionId, \"myTable\")

If the operation is not successful, the revDatabaseColumnNames function returns an error message that begins with the string "revdberr".

Important

The revDatabaseColumnNames function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.

Parameters

Name	Type	Description
recordSetOrConnectionId		The recordSetOrConnectionId is either the number returned by the revQueryDatabase when the record set was created or the number returned by the revOpenDatabase function when the connection was created.
tableName		The name of a table in the current database. A table name should be specified if the recordSetOrConnectionId parameter is a connection id.

Examples

revDatabaseColumnNames(foundResults)

get revDatabaseColumnNames(field "Current Results")

get revDatabaseColumnNames(tConnectionId, "myTable")

Related

library: Database library

control structure: function

function: revDatabaseColumnCount, revDatabaseColumnNamed, revDatabaseColumnTypes, revDatabaseColumnIsNull

glossary: LiveCode custom library, database field, Standalone Application Settings, standalone application, record set, return, SQL query

keyword: string

Compatibility and Support

Introduced

LiveCode 1.1

OS

mac

windows

linux

ios

android

Platforms

desktop

server

mobile